Concurrent Sessions

Using Microsoft ACCESS as a BANNER reporting tool

Tue 4:00 – 4:45PM — Chestnut A
George Tilko, WVNET

This live presentation goes through the necessary steps of setting up an ODBC connection to a Banner instance with the appropriate secure logon screen containing the username and password. The process, once completed will create a shortcut procedure accessible from Microsoft Access making it user friendly and less technical for non-technical staff. Functionality ranges from the simplest wizard selection process to a complex report designing process. Table downloads are rather quick and are the only phase that can result in a database contention issue. Developed processes can be saved and reused with new downloads.

(Return to the list of sessions)